Rows: ??
Columns: 25
Database: DuckDB 1.4.0 [User@Windows 10 x64:R 4.5.1/D:\KSE\Year2-Term1\R\FinalProject\nyc.duckdb]
$ vendor_id <int> 2, 1, 1, 1, 1, 1, 2, 1, 2, 2, 2, 1, 1, 1, 1, 1, …
$ tpep_pickup_datetime <dttm> 2024-01-01 00:57:55, 2024-01-01 00:03:00, 2024-…
$ tpep_dropoff_datetime <dttm> 2024-01-01 01:17:43, 2024-01-01 00:09:36, 2024-…
$ passenger_count <dbl> 1, 1, 1, 1, 1, 1, 2, 0, 1, 1, 2, 2, 2, 2, 1, 1, …
$ trip_distance <dbl> 1.72, 1.80, 4.70, 1.40, 0.80, 4.70, 10.82, 3.00,…
$ ratecode_id <dbl> 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, …
$ store_and_fwd_flag <chr> "N", "N", "N", "N", "N", "N", "N", "N", "N", "N"…
$ pu_location_id <int> 186, 140, 236, 79, 211, 148, 138, 246, 161, 113,…
$ do_location_id <int> 79, 236, 79, 211, 148, 141, 181, 231, 261, 113, …
$ payment_type <dbl> 2, 1, 1, 1, 1, 1, 1, 2, 2, 2, 1, 1, 1, 1, 2, 2, …
$ fare_amount <dbl> 17.7, 10.0, 23.3, 10.0, 7.9, 29.6, 45.7, 25.4, 3…
$ extra <dbl> 1.00, 3.50, 3.50, 3.50, 3.50, 3.50, 6.00, 3.50, …
$ mta_tax <dbl> 0.5, 0.5, 0.5, 0.5, 0.5, 0.5, 0.5, 0.5, 0.5, 0.5…
$ tip_amount <dbl> 0.00, 3.75, 3.00, 2.00, 3.20, 6.90, 10.00, 0.00,…
$ tolls_amount <dbl> 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, …
$ improvement_surcharge <dbl> 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, …
$ total_amount <dbl> 22.70, 18.75, 31.30, 17.00, 16.10, 41.50, 64.95,…
$ congestion_surcharge <dbl> 2.5, 2.5, 2.5, 2.5, 2.5, 2.5, 0.0, 2.5, 2.5, 2.5…
$ airport_fee <dbl> 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 1.75, 0.00, …
$ month <chr> "01", "01", "01", "01", "01", "01", "01", "01", …
$ year <dbl> 2024, 2024, 2024, 2024, 2024, 2024, 2024, 2024, …
$ pu_borough <chr> "Manhattan", "Manhattan", "Manhattan", "Manhatta…
$ pu_zone <chr> "Penn Station/Madison Sq West", "Lenox Hill East…
$ do_borough <chr> "Manhattan", "Manhattan", "Manhattan", "Manhatta…
$ do_zone <chr> "East Village", "Upper East Side North", "East V…